$nazwa_kontynent / $knazwa : $nazwa_grupa", 500);
echo "
";
$i = 0;
$sql = "SELECT COUNT(j.nazwa) AS anz
FROM jednostka AS j, jednostkatyp AS jt
WHERE j.typ_id = jt.id
AND j.inaktiv = 0
AND typ_id = $grupa";
//Debug($sql, "s");
$res = $DB_Base->QueryObject($sql);
$anzahl = $res->anz;
$sql = "SELECT j.id, j.nazwa AS nazwa, jt.nazwa AS typ
FROM jednostka AS j, jednostkatyp AS jt, miasto AS m, panstwo AS p
WHERE j.typ_id = jt.id
AND typ_id = $grupa
AND j.miasto_id = m.id
AND m.panstwo_id = p.id
AND p.id = $panstwo
AND j.inaktiv = 0
ORDER BY nazwa";
//Debug($sql, "s");
$res = $DB_Base->Query($sql);
echo "
| ";
while ($r = mysql_fetch_object($res))
{
$i++;
echo "
";
//$teiler = max(($anzahl/2), 1000);
//if ($i >= $teiler) { echo " | | "; $i = 0; };
};
echo " |
|
";
//******** tutaj jednostki pokazac w tym kraju *********************
/*
echo "| ";
$i = 0;
$sql = "SELECT DISTINCT jt.id, jt.nazwa
FROM jednostkatyp AS jt, jednostka AS j, miasto AS m
WHERE jt.id = j.typ_id AND
j.miasto_id = m.id
AND m.panstwo_id = $panstwo_id
ORDER BY jt.nazwa ASC
";
//Debug($sql, "s");
$res = $DB_Base->Query($sql);
while ($r = mysql_fetch_object($res))
{
$i++;
echo "
";
};
echo " |
";
*/
//******************************************************************
echo "
|
";
?>
|
|
|
